USE [Invoice]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Nhat Hoang
-- Create date: 31/03/2011
-- Description:	sp_SYS_GROUPUSERS_GetById
-- =============================================
CREATE PROCEDURE sp_SYS_GROUPUSERS_GetById
	@groupID int, 
	@userID int
AS
BEGIN
	SELECT [GroupID]
		  ,[UserID]
		  ,[IsUse]
	FROM [SYS_GROUPUSERS]
	WHERE [GroupID] = @groupID AND [UserID] = @userID
END
GO
